package myGroup;

import java.io.File;
import java.io.FileInputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.junit.Test;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;

/**
 * Hello world!
 *
 */
public class App 
{
	@Test
    public void main()
    {
        System.out.println( "Hello World!" );
        WebDriver MyD= new FirefoxDriver();
    }
	
	public void xLR_TC(String sPath) throws Exception {
		System.out.println("Processing Test Cases");
		File myxl = new File(sPath);
		FileInputStream mystream = new FileInputStream(myxl);
		HSSFWorkbook mywb = new HSSFWorkbook(mystream);
		HSSFSheet mysheet = mywb.getSheetAt(2);
		int xTC_rows = mysheet.getLastRowNum() + 1;
		short xTC_cols = mysheet.getRow(0).getLastCellNum();
		System.out.println("rows are" + xTC_rows);
		System.out.println("cols are" + xTC_cols);
		String[][] xTC = new String[xTC_rows][xTC_cols];
		for (int i = 0; i < xTC_rows; i++) {
			HSSFRow row = mysheet.getRow(i);
			for (int j = 0; j < xTC_cols; j++) {
				HSSFCell cell = mysheet.getRow(i).getCell(j);
				String Value = " ";
				System.out.println(Value);
				xTC[i][j] = Value;
			}
		}
	}
}
